Dashboard 01 - Creating Scatter Chart, Map, & Line and Stacked Column charts Visualizations - Part 01 13
In this step, we will continue working on the first dashboard. We will create Scatter Chart, Map, & Line and Clustered Column charts
Step 1: Create Scatter Chart for Violent & Major Crimes & Shootings by District
In Power BI Desktop, click on the page, RaleighPoliceIncidents
Click inside the pane
Visualizations
Click the Scatter Chart icon
Fields
Select the following:
A_KeyMeasures -> .Major_CrimeRate% - Under Visualizations, drag & drop it in the Y Axis section.
A_KeyMeasures -> .Total_Case_Numbers - Under Visualizations, drag & drop it in the Size section.
A_KeyMeasures -> .Total_Shooting_Crimes - Under Visualizations, drag & drop it in the Tooltips section.
A_KeyMeasures -> .Violent_CrimeRate% - Under Visualizations, drag & drop it in the X Axis
Raleigh_Police_Incidents_NIBRS -> District - Under Visualizations, drag & drop it in the Details section
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.Major_CrimeRate% = Major Crime Rate
.Total_Case_Numbers = Total Police Incidents
.Total_Shooting_Crimes = Total Shooting Crimes
Violent_CrimeRate% = Violent Crime Rate
District = District Name
Format tab
Under Format -> General: X Position = 227 , Y Position = 144 , Width = 473 , Height = 409
Under Format -> X Axis -> Scale Type = Linear -> Color = 094780 , Text Size = 10 pt , Font Family = Segoe UI , Title = ON , Style = Show Title Only , Title Color = 000000, Title Text Size = 12 pt, Font Family = DIN , Color = C8C6C4 , Stoke Width 2 , Line Style = Dotted
Under Format -> Y Axis -> Position = Left , Scale Type = Linear -> Color = FCB714 , Text Size = 10 pt , Font Family = Segoe UI , Title = ON , Style = Show Title Only , Title Color = 000000, Title Text Size = 13 pt, Font Family = DIN , Color = C8C6C4 , Stoke Width 2 , Line Style = Dotted
Under Format -> Data Colors -> click fx for Expression -> Format by = Field Value, Based on Field = .Measure_Color
Under Format -> Shapes -> Size = 8 , Marker Shape = . (dot)
Under Format -> Category -> Set it to ON , Color = 000000, Text Size = 12 pt , Font Family = Segoe UI
Under Format -> Slider -> Set it to ON -> Color = 094780
Under
Format -> Title -> Set it to ON , Title Text = Violent & Major Crime Rate & Shootings by District , Font Color
= 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size =
17 pt , Font Family = DIN (Default)
Under Format -> Border -> Set it to ON , Color = 666666
Under Format -> Tooltip -> Set it to ON , Type = Report Page , Text Size = 12 pt, Font Family = Segoe UI , Background Color = 000000 , Transparency = 5%
Analytics tab
Under X-Axis Constant Line 1 -> Click Add -> Value = 0.0595 , Color = 1E5A8E , Transparency = 25% , Line Style = Dashed , Position = In Front
Under Y-Axis Constant Line 1 -> Click Add -> Value = 0.2699, Color = FCB714 , Transparency = 25% , Line Style = Dashed , Position = In Front
Step 2 - Configure Filter(s)
Filters
Under Filters -> District ->
Click on the down arrow -> Filter Type = Basic Filtering, Select all
and Uncheck Unclassified and UNK
Step 3: Create Total Violent & Major Crime Rate Map
Visualizations
Click the Map icon
Fields
Select the following:
A_KeyMeasures -> .Total_Major_Crimes - Under Visualizations, drag & drop it in the Tooltips section.
A_KeyMeasures -> .Total_Violent_Crimes - Under Visualizations, drag & drop it in the Size section.
Raleigh_Police_Incidents_NIBRS -> District - Under Visualizations, drag & drop it in the Tooltips section
Raleigh_Police_Incidents_NIBRS-> Latitude_District - Under Visualizations, drag & drop it in the Latitude section.
Raleigh_Police_Incidents_NIBRS -> Longitude _District - Under Visualizations, drag & drop it in the Longitude section.
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.Total_Major_Crimes = Total Major Crimes
.Total_Violent_Crimes = Total Violent Crimes
District = District Name
Latitude_District = Latitude
Longitude _District = Longitude
Format tab
Under Format -> General: X Position = 227 , Y Position = 553 , Width = 473 , Height = 420
Under Format -> Data Colors -> click fx for Expression -> Format by = Field Value, Based on Field = .Measure_Color
Under Format -> Shapes -> Size = 8 , Marker Shape = . (dot)
Under Format -> Category -> Set it to OFF
Under Format -> Bubbles -> Size = 40
Under Format -> Map Controls -> Auto Zoom = ON , Zoom Buttons = ON
Under
Format -> Title -> Set it to ON , Title Text = Total Violent & Major Crime Rate , Font Color
= 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size =
18 pt , Font Family = DIN (Default)
Under Format -> Border -> Set it to ON , Color = 666666
Step 4 - Configure Filter(s) for Total Violent & Major Crime Rate
Filters
Under Filters -> Latitude -> Click on the down arrow -> Filter Type = Basic Filtering, Select all and Uncheck Blank and 35.645420When finished, save project.
Tips and Tricks for Maps in Power BI